package dao;

import java.util.List;
import org.hibernate.LockMode;
import org.hibernate.Query;
import static org.hibernate.criterion.Example.create;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import entity.TypeBillet;
import javax.ejb.LocalBean;
import javax.ejb.Stateless;

@Stateless
@LocalBean
public class TypeBilletDAO extends BaseHibernateDAO {

    private static final Logger log = LoggerFactory
            .getLogger(TypeBilletDAO.class);

    public void save(TypeBillet transientInstance) {
        log.debug("saving TypeBillet instance");
        try {
            getSession().save(transientInstance);
            log.debug("save successful");
        } catch (RuntimeException re) {
            log.error("save failed", re);
            throw re;
        }
    }

    public void delete(TypeBillet persistentInstance) {
        log.debug("deleting TypeBillet instance");
        try {
            getSession().delete(persistentInstance);
            log.debug("delete successful");
        } catch (RuntimeException re) {
            log.error("delete failed", re);
            throw re;
        }
    }

    public TypeBillet findById(java.lang.Integer id) {
        log.debug("getting TypeBillet instance with id: " + id);
        try {
            TypeBillet instance = (TypeBillet) getSession().get(
                    "entity.TypeBillet", id);
            return instance;
        } catch (RuntimeException re) {
            log.error("get failed", re);
            throw re;
        }
    }

    public List<TypeBillet> findByExample(TypeBillet instance) {
        log.debug("finding TypeBillet instance by example");
        try {
            List<TypeBillet> results = (List<TypeBillet>) getSession()
                    .createCriteria("entity.TypeBillet").add(create(instance))
                    .list();
            log.debug("find by example successful, result size: "
                    + results.size());
            return results;
        } catch (RuntimeException re) {
            log.error("find by example failed", re);
            throw re;
        }
    }

    public List findByProperty(String propertyName, Object value) {
        log.debug("finding TypeBillet instance with property: " + propertyName
                + ", value: " + value);
        try {
            String queryString = "from TypeBillet as model where model."
                    + propertyName + "= ?";
            Query queryObject = getSession().createQuery(queryString);
            queryObject.setParameter(0, value);
            return queryObject.list();
        } catch (RuntimeException re) {
            log.error("find by property name failed", re);
            throw re;
        }
    }

    public List findAll() {
        log.debug("finding all TypeBillet instances");
        try {
            String queryString = "from TypeBillet order by id";
            Query queryObject = getSession().createQuery(queryString);
            return queryObject.list();
        } catch (RuntimeException re) {
            log.error("find all failed", re);
            throw re;
        }
    }

    public List findByTypeAndFes(int idev,String model,String type) {
        log.debug("finding all TypeBillet instances");
        try {
            String queryString = "from TypeBillet where id_evenement="+idev+" and modele like '"+model+"'  and type_carte like '"+type+"' order by id";
            Query queryObject = getSession().createQuery(queryString);
            return queryObject.list();
        } catch (RuntimeException re) {
            log.error("find all failed", re);
            throw re;
        }
    }

    public TypeBillet merge(TypeBillet detachedInstance) {
        log.debug("merging TypeBillet instance");
        try {
            TypeBillet result = (TypeBillet) getSession().merge(
                    detachedInstance);
            log.debug("merge successful");
            return result;
        } catch (RuntimeException re) {
            log.error("merge failed", re);
            throw re;
        }
    }

    public void attachDirty(TypeBillet instance) {
        log.debug("attaching dirty TypeBillet instance");
        try {
            getSession().saveOrUpdate(instance);
            log.debug("attach successful");
        } catch (RuntimeException re) {
            log.error("attach failed", re);
            throw re;
        }
    }

    public void attachClean(TypeBillet instance) {
        log.debug("attaching clean TypeBillet instance");
        try {
            getSession().lock(instance, LockMode.NONE);
            log.debug("attach successful");
        } catch (RuntimeException re) {
            log.error("attach failed", re);
            throw re;
        }
    }
}